
<cfquery name="updateart" datasource="cfartgallery">
update	art
set ARTNAME = 'Mary Oil'
where ARTID = 5
</cfquery>
<cfquery name="getart" datasource="cfartgallery">
select	*
from 	art
</cfquery>

<cfdump var="#getart#" top="10">

<!---
<cf_indexquery indexdirectory="querytest" query="#getart#">
--->

<cf_indexquery indexdirectory="querytest" query="#getart#" storecolumns="artid,artname,description" indexcolumns="artid,artname,description">
